package com.subang.function.mapper;

import java.util.List;
import java.util.Map;

import com.subang.function.domain.SbArticle;
import com.subang.function.domain.SbExamReview;

/**
 * 公考模考复盘Mapper接口
 * 
 * @author subei
 * @date 2025-04-02
 */
public interface SbExamReviewMapper 
{
    /**
     * 查询公考模考复盘
     * 
     * @param id 公考模考复盘主键
     * @return 公考模考复盘
     */
    public SbExamReview selectSbExamReviewById(Long id);

    /**
     * 查询公考模考复盘列表
     * 
     * @param sbExamReview 公考模考复盘
     * @return 公考模考复盘集合
     */
    public List<SbExamReview> selectSbExamReviewList(SbExamReview sbExamReview);

    /**
     * 新增公考模考复盘
     * 
     * @param sbExamReview 公考模考复盘
     * @return 结果
     */
    public int insertSbExamReview(SbExamReview sbExamReview);

    /**
     * 修改公考模考复盘
     * 
     * @param sbExamReview 公考模考复盘
     * @return 结果
     */
    public int updateSbExamReview(SbExamReview sbExamReview);

    /**
     * 删除公考模考复盘
     * 
     * @param id 公考模考复盘主键
     * @return 结果
     */
    public int deleteSbExamReviewById(Long id);

    /**
     * 批量删除公考模考复盘
     * 
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteSbExamReviewByIds(Long[] ids);

    public List<SbExamReview> selectSbExamReviewListByReviewTime(SbExamReview sbExamReview);

    public List<SbExamReview> selectSbExamReviewListByLikes(SbExamReview sbExamReview);

    List<SbExamReview> selectSbExamReviewListByIds(List<Long> ids);

    List<Map<String, Object>> selectGroupExamStatistics(String groupId);

    List<Map<String, Object>> getGroupPersonal(String userId);

    List<Map<String, Object>> getFirepowerRanking(Map<String, Object> params);
}
